UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vDnK2EH5XzNxjBy5T2NBJ0TQB5A94JK72At9ShG3O3M='
WHERE
key_id = '3c63f54576c3555dcdfc06ae0b8905371466eef1f7f08afa89783b9234641d23'
AND (
token = 'vDnK2EH5XzNxjBy5T2NBJ0TQB5A94JK72At9ShG3O3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)