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