UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WITD1R+Q2RsG6UZ2GU5pY5TZ7h1nqbS1Mmd4PD2YLJ0='
WHERE
key_id = '36f12b1f7c0be5ca3b6a6fe37c6fd58ecf6a9aad9d72635c1f3820e36a42600e'
AND (
token = 'WITD1R+Q2RsG6UZ2GU5pY5TZ7h1nqbS1Mmd4PD2YLJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)