UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iikOwb3+7e3JGgyUpWYoDjcrcep8jj4h2sDz5zA0u8='
WHERE
key_id = '6c145bcb0c04078d4659486fdcb46cd74b06c1b1296de09c1fc42e2f71d4a2c0'
AND (
token = '3iikOwb3+7e3JGgyUpWYoDjcrcep8jj4h2sDz5zA0u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)