UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hL+ZswdfEGeydacwRwEgbKOjosZlHK5NA46MpQUGnQc='
WHERE
key_id = 'acecc56ec10ac9394e78f7d4fea08cbf94deb655f2ac17d55a2da518e2042eca'
AND (
token = 'hL+ZswdfEGeydacwRwEgbKOjosZlHK5NA46MpQUGnQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)