UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xD+Jkm6foLkNE1WorAV+7dMIEkxyK7QhC++bweANeqI='
WHERE
key_id = 'f4474e86f64dff9e5e620f3d6020346ff402190c81895302078df693bf1c24b7'
AND (
token = 'xD+Jkm6foLkNE1WorAV+7dMIEkxyK7QhC++bweANeqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)