UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7eLyniHpIuYE3MPSe0Xm/9qRAugvgPbmPW7Hq3dosSA='
WHERE
key_id = '7b981d651a5fbed507912740adf17873709010f9f9c25c3d4dde18780d77a115'
AND (
token = '7eLyniHpIuYE3MPSe0Xm/9qRAugvgPbmPW7Hq3dosSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)