UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PgXA1E/fAF4A7CHfeOUbYFpeXoJlzmWw4saBwqNpWIs='
WHERE
key_id = '6aeb8403ced268509ba699810afce8b38344b0da2e61916718dbd4f9ed6a32c5'
AND (
token = 'PgXA1E/fAF4A7CHfeOUbYFpeXoJlzmWw4saBwqNpWIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)