UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E0tESqpUo6amj73bHnU5gvVkcGARuib1lYNXrrAcAzk='
WHERE
key_id = 'a07a36faed27e249f06fa5d0b86e594cc13faa74aa7d232d8416819cde42c2a2'
AND (
token = 'E0tESqpUo6amj73bHnU5gvVkcGARuib1lYNXrrAcAzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)