UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jg9P3RZ0pm894db1Bh5nLfQ+08uACwkUbNZA3vl6zUY='
WHERE
key_id = '6d980984d5792fa8426fcdd93d4964473ce0288b23207cbdc9eb89a27944ea89'
AND (
token = 'jg9P3RZ0pm894db1Bh5nLfQ+08uACwkUbNZA3vl6zUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)