UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/TBaBZp3Uo9i9wREiaG1tBrVdwfQBSumxr2FI7Wkr+A='
WHERE
key_id = 'a1e411002e26a264d702fd08659a30d50ad91886c1713fd5195aa1dd288323f0'
AND (
token = '/TBaBZp3Uo9i9wREiaG1tBrVdwfQBSumxr2FI7Wkr+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)