UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iZmV12NvCqDIY5wPj+91NCichAlxBX9YFZw4Kw5fu34='
WHERE
key_id = '727d0f89fe50114d293a08affe48cd89266db2c6a847eded5e8bacfeab12dde5'
AND (
token = 'iZmV12NvCqDIY5wPj+91NCichAlxBX9YFZw4Kw5fu34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)