UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VG/sLw5JbIyfQ7kIMBn9ldNEeSxLpPOVk1DzwV7M+9s='
WHERE
key_id = 'd7ea783e08a7dcbef42df5304fc75098f7befd5b236fbc2bfb42986b3f780087'
AND (
token = 'VG/sLw5JbIyfQ7kIMBn9ldNEeSxLpPOVk1DzwV7M+9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)