UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQi12OHNTjO4MRkkCfcn7/xrXuZ6A+HH+rfsezD/Wl4='
WHERE
key_id = '7467c33bcc6952a00a2ad1b30e000f24a2b2d7c86acecf50ad57a0acde6691d2'
AND (
token = 'gQi12OHNTjO4MRkkCfcn7/xrXuZ6A+HH+rfsezD/Wl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)