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