UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bt9NhyPt6Wuy22XNPHJPvSq4NinRFzZpiN2ysmBLwk0='
WHERE
key_id = '1d4ac5ef5925fe266c68dfabe844f50301d27798d6f9fc684d34085da8adc139'
AND (
token = 'Bt9NhyPt6Wuy22XNPHJPvSq4NinRFzZpiN2ysmBLwk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)