UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JTKaeFQ2heuV4YzUyen+PJA+E8Mby+zYyjdF57OGuK4='
WHERE
key_id = 'aae6df91e6e7aec2f530931a6f75e5551e0b316c181c8d879f4a88d3dfeed84b'
AND (
token = 'JTKaeFQ2heuV4YzUyen+PJA+E8Mby+zYyjdF57OGuK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)