UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SWMfM9OTAOrECaAOlao2FQ38S4Ijh1u5xFak+K/b23Y='
WHERE
key_id = 'e99b178de791719ec190be53b0484a42c40a76d0396edf2d32df15c401259fea'
AND (
token = 'SWMfM9OTAOrECaAOlao2FQ38S4Ijh1u5xFak+K/b23Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)