UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNOL9XsR7E86HQksKR2O7Pvp5TXIiMNE2IzR3UIwDHs='
WHERE
key_id = 'b4e9db2373bb06d1c833700e8653dda8485ca05a6e915a75604bcbcc3de3210d'
AND (
token = 'pNOL9XsR7E86HQksKR2O7Pvp5TXIiMNE2IzR3UIwDHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)