UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPZKPgfQqKwGwvt9pjW+YS2IBlxivHO8JLDz3yTuSUI='
WHERE
key_id = 'a94a593171faed7e1ffb7978e89fc9eb6d4be3f4caad034b0c1324414934bda1'
AND (
token = 'HPZKPgfQqKwGwvt9pjW+YS2IBlxivHO8JLDz3yTuSUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)