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