UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mN/LA4eHKpz2pycUJemjtOUpk8ZMEP7QsWAY9J5Kqrs='
WHERE
key_id = '3a86d71ba9ef7c3f0ea92ddc1eba3e7943ea3cb00b35d79a72ebcd174b1ce987'
AND (
token = 'mN/LA4eHKpz2pycUJemjtOUpk8ZMEP7QsWAY9J5Kqrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)