UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ffaibxyzCV9OOqEs7Qs0Fu7CD+LzBK71sBDO1PKpBg='
WHERE
key_id = 'bd782694b7948b07a85d1df397dabbfd60b48c76fa1b25687b715b7218066fbe'
AND (
token = '6ffaibxyzCV9OOqEs7Qs0Fu7CD+LzBK71sBDO1PKpBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)