UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VafTAPyK7hXZT9EsXROqXxMIllq2JZFSI29huDOtxWg='
WHERE
key_id = 'd8c86462f8a9c814dfc83a88285f5ed15af35e75194b23670c80748af1cc22ac'
AND (
token = 'VafTAPyK7hXZT9EsXROqXxMIllq2JZFSI29huDOtxWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)