UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aeAirPegAS69J/MMib7nPO8yaTOkwbXiSs4Uwvf5rao='
WHERE
key_id = 'cd186d346f66a64f498c2aacc10c3d6279709017e16605481ce450e3f3a41514'
AND (
token = 'aeAirPegAS69J/MMib7nPO8yaTOkwbXiSs4Uwvf5rao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)