UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8K8tthKuiTvgJtjVfbzZQQb7AFoekuhHs0Ljk4sfsw='
WHERE
key_id = '4cc5946a47c2059d9bc501dbdaf829b74764e3a5e5f4b8ace5a011e0d227b9b2'
AND (
token = 'c8K8tthKuiTvgJtjVfbzZQQb7AFoekuhHs0Ljk4sfsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)