UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXdJdjiOfQPk1kr8/f606whhV2YpPAZupW+fOPmZHC0='
WHERE
key_id = '6b75a7ae1af28ea167401055ec045fe1f49d24ac18c019ead0dd59cf76d7fa10'
AND (
token = 'cXdJdjiOfQPk1kr8/f606whhV2YpPAZupW+fOPmZHC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)