UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zLlGHNNgcaK3VOovWeQ1C09yBPKhoBOhgCxt4Onshc='
WHERE
key_id = 'e1cc7675cfd2111e3461b59d3f387f49a0af902e8b4ecdd2d7dfc32ef0b970dd'
AND (
token = '+zLlGHNNgcaK3VOovWeQ1C09yBPKhoBOhgCxt4Onshc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)