UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HVPjgNhlTmUWBshMhvIAq/WWlieTPni+pj36PpuZHKA='
WHERE
key_id = '357ad9c55cfb747d7a5fc000f0da2b108840a6f1f08c570c33e39920de8d0907'
AND (
token = 'HVPjgNhlTmUWBshMhvIAq/WWlieTPni+pj36PpuZHKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)