UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MP/4oGedLKKQwhjgqCinv3O5ZiG4n2unh8RylkS8Bg='
WHERE
key_id = '7b97f14321c6818164ba262132dc5b1778b66b242ded77a80105488044cc04ec'
AND (
token = '0MP/4oGedLKKQwhjgqCinv3O5ZiG4n2unh8RylkS8Bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)