UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RndU8uh7OUXkLH861pK7xh4AOABn1WdzE2orLeWMHe0='
WHERE
key_id = '0dfcf6bb34afc1144798780cf8a79bb7323e78814dc258e0b782b6a321e982f0'
AND (
token = 'RndU8uh7OUXkLH861pK7xh4AOABn1WdzE2orLeWMHe0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)