UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '32PgMHGVE9MaOsJmkiZL4AtzqZOF7WIp7g00A4plvNo='
WHERE
key_id = 'abbd49408062ebde272b602931448b4b916cfc8841effcf1d9c7924bfdf32f0d'
AND (
token = '32PgMHGVE9MaOsJmkiZL4AtzqZOF7WIp7g00A4plvNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)