UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trPOHqafcVpCXBrDrLcfibIA6Zpi9kVX+N6ycNx9ct0='
WHERE
key_id = 'b9381571d38cdb4eab12f707e9ec9d7d9155dee916523e34b8d7c86dfab34017'
AND (
token = 'trPOHqafcVpCXBrDrLcfibIA6Zpi9kVX+N6ycNx9ct0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)