UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZFn3u72mDpqndT0ac70obYEZmbF9sR3aGcOWcvzq72U='
WHERE
key_id = '739f8cdeeaf3169e0ed22bc26d58c9715531c6e1bf69baacafb3b77e4d89f40a'
AND (
token = 'ZFn3u72mDpqndT0ac70obYEZmbF9sR3aGcOWcvzq72U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)