UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnEEYoubeRJDoZFT0poBdPFkm6r9uRNGMRwDvWvBzcc='
WHERE
key_id = '5d8858c098fd22f653926413158edf776f8a0877e897099ab15e8fa3b94daf67'
AND (
token = 'XnEEYoubeRJDoZFT0poBdPFkm6r9uRNGMRwDvWvBzcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)