UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zon/3q9wOjDDanNBNHfVk/xn+0+wVgKKiL/zjd4NzO8='
WHERE
key_id = 'de784a019b18fcdecf1a2b7afe1531b22a817cd84d6c43a56699064c26afbf59'
AND (
token = 'zon/3q9wOjDDanNBNHfVk/xn+0+wVgKKiL/zjd4NzO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)