UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EFU/5kQ+mG18M60JYT3iOzX1nB+twpAO3dGb/8JeGV8='
WHERE
key_id = '1e747b0de1a5caa8317bb67bd7085a52a9abf032c044ddf591528d3f8ad347e2'
AND (
token = 'EFU/5kQ+mG18M60JYT3iOzX1nB+twpAO3dGb/8JeGV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)