UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVRIdLfA8XewA+s8U4cPrLDABAX35bIa/b6qjvc85uc='
WHERE
key_id = '2a3074eb6907d6a8afa4b31f6edc7a3f3ef92797295f4d0fe1d4b0803df2f354'
AND (
token = 'ZVRIdLfA8XewA+s8U4cPrLDABAX35bIa/b6qjvc85uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)