UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qX/jDKVhMNyT4ZdFdZNtMaek/T+eYz5+B/4MTzP6lyo='
WHERE
key_id = 'cb76333f0cd7acb8f99b374758462a46976360d9f1053c6e4aefab23963abf86'
AND (
token = 'qX/jDKVhMNyT4ZdFdZNtMaek/T+eYz5+B/4MTzP6lyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)