UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JQR8/pDIU07Qyxq1uO8btn+TrAiFDtxBTmuyb1aXIJ0='
WHERE
key_id = '05bdf0ee42dc3ca3aa9891825fc6d7362dd512ecac4fb7e4af882c9adcf1ed3e'
AND (
token = 'JQR8/pDIU07Qyxq1uO8btn+TrAiFDtxBTmuyb1aXIJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)