UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0a2MXAl763d81kBEwv1jA3Yn1poBf1fBPM06Nx23RyM='
WHERE
key_id = 'c8d8b6849e8e282ffcd8943d199595fc3e70be78a2814769e7ef8a2901e93a68'
AND (
token = '0a2MXAl763d81kBEwv1jA3Yn1poBf1fBPM06Nx23RyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)