UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pn1k+rIYLdx4zlQjiaJaERgvOmM1AWeoJiqfOABExOg='
WHERE
key_id = '30442543cc40be5240389edcc9b090d843a865c588d7e6e71c06822960b51e0c'
AND (
token = 'Pn1k+rIYLdx4zlQjiaJaERgvOmM1AWeoJiqfOABExOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)