UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/3zbHltApjGVKq22qAIpVaRbE8fSZlrk6YJLABEM3UE='
WHERE
key_id = '89b8366580f98776dd53c1e720b22c26dd9714cdecc7190128347163ed2a2636'
AND (
token = '/3zbHltApjGVKq22qAIpVaRbE8fSZlrk6YJLABEM3UE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)