UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpZ3G3cwE0al4I7+WpTeyuauEfIOlBbYNpD4xqYA27w='
WHERE
key_id = '9b185407efa1376f36df23a5e6ada3eab5cd4217bd8893e3fcb8f9a194e6eb84'
AND (
token = 'bpZ3G3cwE0al4I7+WpTeyuauEfIOlBbYNpD4xqYA27w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)