UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XE4aLNdSnqe4//wycGmYbWFaxPSzi7C80TFBvgBTcNE='
WHERE
key_id = '7fd7cd732053f4d789426f652a80cd22e79c0e31ff76616b2b967cfea551c4ad'
AND (
token = 'XE4aLNdSnqe4//wycGmYbWFaxPSzi7C80TFBvgBTcNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)