UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zn+IjDh3poEIKvoAsGRKtSCoeS5Zd56d9dEHNdYYqRk='
WHERE
key_id = '3527b2dcba98f077d720ccb7556105026fc27619102b06ccf9df12eaeee0553e'
AND (
token = 'Zn+IjDh3poEIKvoAsGRKtSCoeS5Zd56d9dEHNdYYqRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)