UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6/cRx4H0EfEGe2BP5b5BxQgazC3CXEmYbaldTOYvoEI='
WHERE
key_id = '4989115ac3c61a81ed51ea71ee45ade45967ce1bcc394f415718260f7ea738c9'
AND (
token = '6/cRx4H0EfEGe2BP5b5BxQgazC3CXEmYbaldTOYvoEI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)